The use of UML to design agricultural data warehouses
Identifieur interne : 000082 ( France/Analysis ); précédent : 000081; suivant : 000083The use of UML to design agricultural data warehouses
Auteurs : Franc Ois Pinet [France] ; André Miralles [France] ; Sandro Bimonte [France] ; Franc Oise Vernier [France] ; Nadia Carluer [France] ; Ve Ronique Gouy [France] ; Stephan Bernard [France]Source :
Descripteurs français
- mix :
English descriptors
Abstract
Recent research works propose to use the Unified Modeling Language (UML) to design datawarehouses. First, the paper overviews these recent UML-based techniques. We show that UML can help system designers to build a data warehouse model. This type of model aims to describe the different analysis dimensions of the data. Second, we will also present different UML-based tools used during a project of agricultural data warehouse. The paper will introduce this data warehouse developed in France. Its goal is to allow analyzing spatially the use of pesticide in agriculture.
Url:
Affiliations:
Links toward previous steps (curation, corpus...)
- to stream Hal, to step Corpus: 000023
- to stream Hal, to step Curation: 000023
- to stream Hal, to step Checkpoint: 000040
- to stream Main, to step Merge: 000629
- to stream Main, to step Curation: 000629
- to stream Main, to step Exploration: 000629
- to stream France, to step Extraction: 000082
Links to Exploration step
Hal:hal-00525347Le document en format XML
<record><TEI><teiHeader><fileDesc><titleStmt><title xml:lang="en">The use of UML to design agricultural data warehouses</title>
<author><name sortKey="Pinet, Franc Ois" sort="Pinet, Franc Ois" uniqKey="Pinet F" first="Franc Ois" last="Pinet">Franc Ois Pinet</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Miralles, Andre" sort="Miralles, Andre" uniqKey="Miralles A" first="André" last="Miralles">André Miralles</name>
<affiliation wicri:level="1"><hal:affiliation type="researchteam" xml:id="struct-388310" status="OLD"> <orgName>Fouille de données environnementales</orgName>
<orgName type="acronym">LIRMM/TATOO</orgName>
<date type="end">2013</date>
<desc> <address> <country key="FR"></country>
</address>
</desc>
<listRelation> <relation active="#struct-181" type="direct"></relation>
<relation name="UMR5506" active="#struct-441569" type="indirect"></relation>
<relation name="UMR5506" active="#struct-410122" type="indirect"></relation>
</listRelation>
<tutelles><tutelle active="#struct-181" type="direct"><org type="laboratory" xml:id="struct-181" status="VALID"> <idno type="RNSR">199111950H</idno>
<idno type="ISNI">0000000405990488</idno>
<orgName>Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier</orgName>
<orgName type="acronym">LIRMM</orgName>
<date type="start">1995</date>
<desc> <address> <addrLine>CC 477, 161 rue Ada, 34095 Montpellier Cedex 5</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.lirmm.fr</ref>
</desc>
<listRelation> <relation name="UMR5506" active="#struct-441569" type="direct"></relation>
<relation name="UMR5506" active="#struct-410122" type="direct"></relation>
</listRelation>
</org>
</tutelle>
<tutelle name="UMR5506" active="#struct-441569" type="indirect"><org type="institution" xml:id="struct-441569" status="VALID"><idno type="IdRef">02636817X</idno>
<idno type="ISNI">0000000122597504</idno>
<orgName>Centre National de la Recherche Scientifique</orgName>
<orgName type="acronym">CNRS</orgName>
<date type="start">1939-10-19</date>
<desc><address><country key="FR"></country>
</address>
<ref type="url">http://www.cnrs.fr/</ref>
</desc>
</org>
</tutelle>
<tutelle name="UMR5506" active="#struct-410122" type="indirect"><org type="institution" xml:id="struct-410122" status="VALID"> <idno type="ISNI">0000000120970141</idno>
<orgName>Université de Montpellier</orgName>
<orgName type="acronym">UM</orgName>
<desc> <address> <addrLine>163 rue Auguste Broussonnet - 34090 Montpellier</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.umontpellier.fr/</ref>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Bimonte, Sandro" sort="Bimonte, Sandro" uniqKey="Bimonte S" first="Sandro" last="Bimonte">Sandro Bimonte</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Vernier, Franc Oise" sort="Vernier, Franc Oise" uniqKey="Vernier F" first="Franc Oise" last="Vernier">Franc Oise Vernier</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18350" status="OLD"><orgName>Aménités et dynamiques des espaces ruraux</orgName>
<orgName type="acronym">UR ADBX</orgName>
<desc><address><addrLine>50 avenue de Verdun - Gazinet, F-33612 Cestas</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Carluer, Nadia" sort="Carluer, Nadia" uniqKey="Carluer N" first="Nadia" last="Carluer">Nadia Carluer</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-102840" status="OLD"> <orgName>Milieux aquatiques, écologie et pollutions</orgName>
<orgName type="acronym">UR MALY</orgName>
<desc> <address> <addrLine>3 bis quai Chauveau - CP 220, F-69336 Lyon</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation> <relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Gouy, Ve Ronique" sort="Gouy, Ve Ronique" uniqKey="Gouy V" first="Ve Ronique" last="Gouy">Ve Ronique Gouy</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-102840" status="OLD"> <orgName>Milieux aquatiques, écologie et pollutions</orgName>
<orgName type="acronym">UR MALY</orgName>
<desc> <address> <addrLine>3 bis quai Chauveau - CP 220, F-69336 Lyon</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation> <relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Bernard, Stephan" sort="Bernard, Stephan" uniqKey="Bernard S" first="Stephan" last="Bernard">Stephan Bernard</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
</titleStmt>
<publicationStmt><idno type="wicri:source">HAL</idno>
<idno type="RBID">Hal:hal-00525347</idno>
<idno type="halId">hal-00525347</idno>
<idno type="halUri">https://hal.archives-ouvertes.fr/hal-00525347</idno>
<idno type="url">https://hal.archives-ouvertes.fr/hal-00525347</idno>
<date when="2010-09-06">2010-09-06</date>
<idno type="wicri:Area/Hal/Corpus">000023</idno>
<idno type="wicri:Area/Hal/Curation">000023</idno>
<idno type="wicri:Area/Hal/Checkpoint">000040</idno>
<idno type="wicri:explorRef" wicri:stream="Hal" wicri:step="Checkpoint">000040</idno>
<idno type="wicri:Area/Main/Merge">000629</idno>
<idno type="wicri:Area/Main/Curation">000629</idno>
<idno type="wicri:Area/Main/Exploration">000629</idno>
<idno type="wicri:Area/France/Extraction">000082</idno>
</publicationStmt>
<sourceDesc><biblStruct><analytic><title xml:lang="en">The use of UML to design agricultural data warehouses</title>
<author><name sortKey="Pinet, Franc Ois" sort="Pinet, Franc Ois" uniqKey="Pinet F" first="Franc Ois" last="Pinet">Franc Ois Pinet</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Miralles, Andre" sort="Miralles, Andre" uniqKey="Miralles A" first="André" last="Miralles">André Miralles</name>
<affiliation wicri:level="1"><hal:affiliation type="researchteam" xml:id="struct-388310" status="OLD"> <orgName>Fouille de données environnementales</orgName>
<orgName type="acronym">LIRMM/TATOO</orgName>
<date type="end">2013</date>
<desc> <address> <country key="FR"></country>
</address>
</desc>
<listRelation> <relation active="#struct-181" type="direct"></relation>
<relation name="UMR5506" active="#struct-441569" type="indirect"></relation>
<relation name="UMR5506" active="#struct-410122" type="indirect"></relation>
</listRelation>
<tutelles><tutelle active="#struct-181" type="direct"><org type="laboratory" xml:id="struct-181" status="VALID"> <idno type="RNSR">199111950H</idno>
<idno type="ISNI">0000000405990488</idno>
<orgName>Laboratoire d'Informatique de Robotique et de Microélectronique de Montpellier</orgName>
<orgName type="acronym">LIRMM</orgName>
<date type="start">1995</date>
<desc> <address> <addrLine>CC 477, 161 rue Ada, 34095 Montpellier Cedex 5</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.lirmm.fr</ref>
</desc>
<listRelation> <relation name="UMR5506" active="#struct-441569" type="direct"></relation>
<relation name="UMR5506" active="#struct-410122" type="direct"></relation>
</listRelation>
</org>
</tutelle>
<tutelle name="UMR5506" active="#struct-441569" type="indirect"><org type="institution" xml:id="struct-441569" status="VALID"><idno type="IdRef">02636817X</idno>
<idno type="ISNI">0000000122597504</idno>
<orgName>Centre National de la Recherche Scientifique</orgName>
<orgName type="acronym">CNRS</orgName>
<date type="start">1939-10-19</date>
<desc><address><country key="FR"></country>
</address>
<ref type="url">http://www.cnrs.fr/</ref>
</desc>
</org>
</tutelle>
<tutelle name="UMR5506" active="#struct-410122" type="indirect"><org type="institution" xml:id="struct-410122" status="VALID"> <idno type="ISNI">0000000120970141</idno>
<orgName>Université de Montpellier</orgName>
<orgName type="acronym">UM</orgName>
<desc> <address> <addrLine>163 rue Auguste Broussonnet - 34090 Montpellier</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.umontpellier.fr/</ref>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Bimonte, Sandro" sort="Bimonte, Sandro" uniqKey="Bimonte S" first="Sandro" last="Bimonte">Sandro Bimonte</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Vernier, Franc Oise" sort="Vernier, Franc Oise" uniqKey="Vernier F" first="Franc Oise" last="Vernier">Franc Oise Vernier</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18350" status="OLD"><orgName>Aménités et dynamiques des espaces ruraux</orgName>
<orgName type="acronym">UR ADBX</orgName>
<desc><address><addrLine>50 avenue de Verdun - Gazinet, F-33612 Cestas</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Carluer, Nadia" sort="Carluer, Nadia" uniqKey="Carluer N" first="Nadia" last="Carluer">Nadia Carluer</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-102840" status="OLD"> <orgName>Milieux aquatiques, écologie et pollutions</orgName>
<orgName type="acronym">UR MALY</orgName>
<desc> <address> <addrLine>3 bis quai Chauveau - CP 220, F-69336 Lyon</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation> <relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Gouy, Ve Ronique" sort="Gouy, Ve Ronique" uniqKey="Gouy V" first="Ve Ronique" last="Gouy">Ve Ronique Gouy</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-102840" status="OLD"> <orgName>Milieux aquatiques, écologie et pollutions</orgName>
<orgName type="acronym">UR MALY</orgName>
<desc> <address> <addrLine>3 bis quai Chauveau - CP 220, F-69336 Lyon</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation> <relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
<author><name sortKey="Bernard, Stephan" sort="Bernard, Stephan" uniqKey="Bernard S" first="Stephan" last="Bernard">Stephan Bernard</name>
<affiliation wicri:level="1"><hal:affiliation type="laboratory" xml:id="struct-18355" status="OLD"><orgName>Technologies et systèmes d'information pour les agrosystèmes</orgName>
<orgName type="acronym">UR TSCF</orgName>
<desc><address><addrLine>24 avenue des Landais - BP 20085, F-63172 Aubière</addrLine>
<country key="FR"></country>
</address>
<ref type="url">http://www.cemagref.fr</ref>
</desc>
<listRelation><relation active="#struct-300005" type="direct"></relation>
</listRelation>
<tutelles><tutelle active="#struct-300005" type="direct"><org type="institution" xml:id="struct-300005" status="OLD"> <orgName>CEMAGREF</orgName>
<desc> <address> <country key="FR"></country>
</address>
</desc>
</org>
</tutelle>
</tutelles>
</hal:affiliation>
<country>France</country>
</affiliation>
</author>
</analytic>
</biblStruct>
</sourceDesc>
</fileDesc>
<profileDesc><textClass><keywords scheme="mix" xml:lang="en"><term>DATA WAREHOUSE</term>
<term>SPATIAL INFORMATION</term>
</keywords>
<keywords scheme="mix" xml:lang="fr"><term>AGRICULTURE</term>
<term>ENTREPOT DE DONNEES</term>
<term>LANGAGE UML</term>
<term>PESTICIDE</term>
<term>SYSTEME D'INFORMATION A REFERENCE SPATIALE</term>
</keywords>
</textClass>
</profileDesc>
</teiHeader>
<front><div type="abstract" xml:lang="en">Recent research works propose to use the Unified Modeling Language (UML) to design datawarehouses. First, the paper overviews these recent UML-based techniques. We show that UML can help system designers to build a data warehouse model. This type of model aims to describe the different analysis dimensions of the data. Second, we will also present different UML-based tools used during a project of agricultural data warehouse. The paper will introduce this data warehouse developed in France. Its goal is to allow analyzing spatially the use of pesticide in agriculture.</div>
</front>
</TEI>
<affiliations><list><country><li>France</li>
</country>
</list>
<tree><country name="France"><noRegion><name sortKey="Pinet, Franc Ois" sort="Pinet, Franc Ois" uniqKey="Pinet F" first="Franc Ois" last="Pinet">Franc Ois Pinet</name>
</noRegion>
<name sortKey="Bernard, Stephan" sort="Bernard, Stephan" uniqKey="Bernard S" first="Stephan" last="Bernard">Stephan Bernard</name>
<name sortKey="Bimonte, Sandro" sort="Bimonte, Sandro" uniqKey="Bimonte S" first="Sandro" last="Bimonte">Sandro Bimonte</name>
<name sortKey="Carluer, Nadia" sort="Carluer, Nadia" uniqKey="Carluer N" first="Nadia" last="Carluer">Nadia Carluer</name>
<name sortKey="Gouy, Ve Ronique" sort="Gouy, Ve Ronique" uniqKey="Gouy V" first="Ve Ronique" last="Gouy">Ve Ronique Gouy</name>
<name sortKey="Miralles, Andre" sort="Miralles, Andre" uniqKey="Miralles A" first="André" last="Miralles">André Miralles</name>
<name sortKey="Vernier, Franc Oise" sort="Vernier, Franc Oise" uniqKey="Vernier F" first="Franc Oise" last="Vernier">Franc Oise Vernier</name>
</country>
</tree>
</affiliations>
</record>
Pour manipuler ce document sous Unix (Dilib)
EXPLOR_STEP=$WICRI_ROOT/Wicri/Agronomie/explor/SisAgriV1/Data/France/Analysis
HfdSelect -h $EXPLOR_STEP/biblio.hfd -nk 000082 | SxmlIndent | more
Ou
HfdSelect -h $EXPLOR_AREA/Data/France/Analysis/biblio.hfd -nk 000082 | SxmlIndent | more
Pour mettre un lien sur cette page dans le réseau Wicri
{{Explor lien |wiki= Wicri/Agronomie |area= SisAgriV1 |flux= France |étape= Analysis |type= RBID |clé= Hal:hal-00525347 |texte= The use of UML to design agricultural data warehouses }}
This area was generated with Dilib version V0.6.28. |